<%@ page language="java" contentType="text/html; charset=BIG5"
    pageEncoding="BIG5"%>
<%@page import="Annotation.DataBase.*"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=BIG5">
<title>Insert title here</title>
</head>

<%
String stdnumID = request.getParameter("stdnum");
//String courseID = request.getParameter("courseID");

%>


<body>

<form name="form1" id="form1" method="post" action="manageCourseStudent4_SaveChanges.jsp">

<table>
<%
MySQLCommand ss1= new MySQLCommand();
String sql1="select student_number,student_name from student_info WHERE PK_student_info='"+stdnumID+"';";
ResultSet rs1 = ss1.selectSQL(sql1);

out.println(sql1);
%>

<%
while(rs1.next()){
	String rm0=rs1.getString("student_number");
	String rm1=rs1.getString("student_name");
%>

<input type="hidden" id="studentID" name="studentID" value=<%=stdnumID%> width="100%" /> 
    
		<tr>
		
			<td width="40%" align="left">Student number</td>
	    	<td width="60%" align="center">
	    		<input type="text" id="studentnumber" name="studentnumber" value=<%=rm0%> width="100%" /> 
	    	</td>
	    </tr>
	    
	    <tr>
	    	<td width="40%" align="left">Student name</td>
	    	<td width="60%" align="center">
	    		<input type="text" id="studentname" name="studentname" value=<%=rm1%> width="100%" /> 
	    	</td>
	    </tr>	
	    	
	    <tr>	
	    	<td colspan="2" align="center">
	    		<input type="button" onClick="submit()" value="Save Change" />
	    	</td>
	    	
		</tr>
<%
}
%>
</table>
</form>


</body>
</html>